Use the Index Name edit box to set the index name. No schema name can be included here; the index is always created in the same schema as its parent table.
To include field(s) in the index, just simply double-click the Fields
field or click to open the editor for editing.
Note: Some of field types do not allow indexing by several fields.
The Index Type dropdown list defines the type of the table index. PostgreSQL provides the index methods B-tree, R-tree, hash, and GiST. The B-tree index method is an implementation of Lehman-Yao high-concurrency B-trees. The R-tree index method implements standard R-trees using Guttman's quadratic split algorithm. The hash index method is an implementation of Litwin's linear hashing. Users can also define their own index methods, but that is fairly complicated.
Unique
Makes index unique, causes the system to check for duplicate values in the table when the index is created (if data already exist) and each time data is added.
Cluster
CLUSTER instructs PostgreSQL to cluster the table specified by tablename based on the
index specified by indexname. The index must already have been defined on tablename.
When a table is clustered, PostgreSQL remembers on which index it was clustered. The form CLUSTER tablename reclusters the table on the same index that it was clustered before.
Tablespace
The tablespace in which to create the index.
Constraints
If you wish to create partial index, enter constraint condition in this edit box.
A partial index is an index that contains entries for only a portion of a table, usually a portion
that is more useful for indexing than the rest of the table.
Fill Factor
The fillfactor for an index.
Note: Support from PostgreSQL 8.2 or later.
The Comment edit box defines the comment for the index.